package com.dingding.service.activity.core.sql;

/**
 * 
 * @ClassName: UserCouponSQL 
 * @Description: 用户优惠券SQL类
 * @author YHQ
 * @date 2016年12月23日 上午10:33:41
 * @since V2.6.3
 * 
 */
public class UserCouponSQL {

	/**
	 * 
	 * @author YHQ
	 * @Description: 获取即将过期优惠券数量
	 * 
	 */
	public static final String GET_EXPIRED_COUPON_NUMBER = "SELECT COUNT(TIMESTAMPDIFF(DAY,NOW(),u.expiredTime)) AS expiredCouponNumber FROM usercoupon u WHERE TIMESTAMPDIFF(DAY,NOW(),u.expiredTime) BETWEEN 0 AND 3 AND u.loginId = ?";
	
}
